Transformation scope
In the Transformation scope screen, you define which tables will be affected by the transformation. For example, you can apply the rule to all tables that contain the word SALARY as part of their name.
The options displayed in this screen depend on the selected Transformation Type.
The following table describes all available options. The second column lists the Transformation Type where the option to be available.
| Option | Transformation Type | Description |
|---|---|---|
|
Schema name is like % |
All |
Leave the % sign to include all schemas in your global transformation. Click the % sign to add a filter. In this case you can enter any name combination to include only that schema in your global transformation rule. For example, enter HR to include only tables that have the schema HR. You can use the % sign as a wildcard. For example, H% includes all tables with a schema that begins with the letter H, such as HR, HELLO, or HQ. The % wildcard can be used in any position. For example, if you use it at the beginning, %H, then all table names that end in H are included in the transformation rule. The % can also be used in a middle position. Information note
If you are using an Oracle target, you must enter a schema that exists on the target endpoint. Qlik Replicate does not create new schemas on an Oracle endpoint. If you want to use a new schema for the target, create the schema on the Oracle endpoint before running the task. For more information, see the topic "Configuring an Oracle database as a Qlik Replicate Target" in the Qlik Replicate User and Reference Guide. |
|
Change table tablespace |
Information note
This option is only available if the task is defined with an Oracle target endpoint. Leave the % sign to include all table tablespace names in your global transformation. Click the % sign to add a filter. In this case, you can enter any name combination to include only the specified table tablespace in your global transformation rule. For example, enter SYSTEM to include only table tablespaces called SYSTEM. You can also use the % sign as a wildcard anywhere in the string. For example, H% includes all table tablespaces that begin with the letter "H" whereas %H includes all table tablespaces that end with the letter "H". |
|
|
Change index tablespace |
Information note
This option is only available if the task is defined with an Oracle target endpoint. Leave the % sign to include all index tablespace names in your global transformation. Click the % sign to add a filter. In this case, you can enter any name combination to include only the specified index tablespace in your global transformation rule. For example, enter SYSTEM to include only index tablespaces called SYSTEM. You can also use the % sign as a wildcard anywhere in the string. For example, H% includes all index tablespaces that begin with the letter "H" whereas %H includes all index tablespaces that end with the letter "H". |
|
|
Table name is like % |
All |
Leave the % sign to include all table names in your global transformation rule. Click the % sign to add a filter. In this case you can enter any name combination to include only tables with that specific name in your global transformation rule. You can use the % sign as a wildcard. For example, J% includes all tables with a name that begins with the letter J, such as JOBS, JOBS_HISTORY, or JACKSONVILLE. The % wildcard can be used in any position. For example, if you use it at the beginning, %H, then all table names that end in H are included in the transformation rule. The % can also be used in a middle position. |
|
Column name is like % |
Rename column Drop column Convert data type Replace column value |
Leave the % sign to include all column names in your global transformation rule. Click the % sign to add a filter. In this case you can enter any name combination to include only columns with that specific name in your global transformation rule. You can use the % sign as a wildcard. For example, N% includes all columns with a name that begins with the letter N, such as NAME, NAME_FIRST, or NAME_LAST. The % wildcard can be used in any position. For example, if you use it at the beginning, %IES, then all column names that end in with the string "IES" are included in the transformation rule. The % can also be used in a middle position. |
|
Data type is |
Convert data type Replace column value |
Select a new data type from the drop-down list. Make sure that the data type you select is compatible with the data in that column. For a description of Qlik Replicate data types, information about data type mapping from the native endpoint to Qlik Replicate, or for a list of endpoints supported by Qlik Replicate, see the Qlik Replicate User and Reference Guide. |
| Scope expression |
All | Click Advanced options to define a scope expression using the Expression Builder. |
After you complete defining the transformation rule definitions, click Next to go to the Transformation action step.
If the global transformation type you are defining is Drop Column, you do not need to create a Transformation Rule. In this case, click Finish to add the rule to the Global Rules list.